Overview

Dataset statistics

Number of variables22
Number of observations13540
Missing cells13540
Missing cells (%)4.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.3 MiB
Average record size in memory176.0 B

Variable types

NUM17
BOOL3
UNSUPPORTED1
CAT1

Reproduction

Analysis started2020-08-03 22:31:19.890036
Analysis finished2020-08-03 22:32:06.090524
Duration46.2 seconds
Versionpandas-profiling v2.8.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Warnings

symbol is highly correlated with df_indexHigh correlation
df_index is highly correlated with symbolHigh correlation
nbb is highly correlated with lastprice and 2 other fieldsHigh correlation
lastprice is highly correlated with nbb and 2 other fieldsHigh correlation
nbo is highly correlated with lastprice and 2 other fieldsHigh correlation
currentreferenceprice is highly correlated with lastprice and 2 other fieldsHigh correlation
week is highly correlated with quarter and 1 other fieldsHigh correlation
quarter is highly correlated with week and 1 other fieldsHigh correlation
month is highly correlated with quarter and 1 other fieldsHigh correlation
pct_move_snapshot_to_close has 13540 (100.0%) missing values Missing
matched_to_unmatched is highly skewed (γ1 = 44.00783743) Skewed
df_index has unique values Unique
pct_move_snapshot_to_close is an unsupported type, check if it needs cleaning or further analysis Unsupported
nearindicativeprice has 3622 (26.8%) zeros Zeros
farindicativeprice has 7729 (57.1%) zeros Zeros
minute has 2701 (19.9%) zeros Zeros
day has 1975 (14.6%) zeros Zeros
week has 1964 (14.5%) zeros Zeros
month has 1964 (14.5%) zeros Zeros

Variables

df_index
Real number (ℝ≥0)

HIGH CORRELATION
UNIQUE

Distinct count13540
Unique (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6824.6439438700145
Minimum0
Maximum13653
Zeros1
Zeros (%)< 0.1%
Memory size105.8 KiB
2020-08-03T17:32:06.137616image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile679.95
Q13409.75
median6825.5
Q310238.25
95-th percentile12972.05
Maximum13653
Range13653
Interquartile range (IQR)6828.5

Descriptive statistics

Standard deviation3942.111345
Coefficient of variation (CV)0.5776288664
Kurtosis-1.199112826
Mean6824.643944
Median Absolute Deviation (MAD)3414.5
Skewness0.0005596608777
Sum92405679
Variance15540241.86
2020-08-03T17:32:06.257694image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
20471< 0.1%
 
26601< 0.1%
 
47591< 0.1%
 
68061< 0.1%
 
6611< 0.1%
 
27081< 0.1%
 
129471< 0.1%
 
88491< 0.1%
 
108961< 0.1%
 
47431< 0.1%
 
Other values (13530)1353099.9%
 
ValueCountFrequency (%) 
01< 0.1%
 
11< 0.1%
 
21< 0.1%
 
31< 0.1%
 
41< 0.1%
 
ValueCountFrequency (%) 
136531< 0.1%
 
136521< 0.1%
 
136511< 0.1%
 
136501< 0.1%
 
136491< 0.1%
 

symbol
Real number (ℝ≥0)

HIGH CORRELATION

Distinct count993
Unique (%)7.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.49716573057130614
Minimum0.0
Maximum1.0
Zeros14
Zeros (%)0.1%
Memory size105.8 KiB
2020-08-03T17:32:06.377089image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.04838709677
Q10.2469758065
median0.4959677419
Q30.7469758065
95-th percentile0.9495967742
Maximum1
Range1
Interquartile range (IQR)0.5

Descriptive statistics

Standard deviation0.288779035
Coefficient of variation (CV)0.5808506445
Kurtosis-1.19821321
Mean0.4971657306
Median Absolute Deviation (MAD)0.25
Skewness0.009155092402
Sum6731.623992
Variance0.08339333107
2020-08-03T17:32:06.476087image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.1633064516140.1%
 
0.9122983871140.1%
 
0.4868951613140.1%
 
0.2963709677140.1%
 
0.7066532258140.1%
 
0.591733871140.1%
 
0.6975806452140.1%
 
0.2096774194140.1%
 
0.7510080645140.1%
 
0.6199596774140.1%
 
Other values (983)1340099.0%
 
ValueCountFrequency (%) 
0140.1%
 
0.001008064516140.1%
 
0.002016129032140.1%
 
0.003024193548140.1%
 
0.004032258065140.1%
 
ValueCountFrequency (%) 
1140.1%
 
0.9989919355140.1%
 
0.997983871140.1%
 
0.9969758065140.1%
 
0.9959677419140.1%
 

currentvolume
Real number (ℝ≥0)

Distinct count13508
Unique (%)99.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.019859587586763282
Minimum0.0
Maximum1.0
Zeros1
Zeros (%)< 0.1%
Memory size105.8 KiB
2020-08-03T17:32:06.587681image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.000987772694
Q10.003019574097
median0.007153717859
Q30.01761479611
95-th percentile0.07362790921
Maximum1
Range1
Interquartile range (IQR)0.01459522201

Descriptive statistics

Standard deviation0.04681279213
Coefficient of variation (CV)2.357188533
Kurtosis102.3919017
Mean0.01985958759
Median Absolute Deviation (MAD)0.005137799498
Skewness8.187461622
Sum268.8988159
Variance0.002191437507
2020-08-03T17:32:06.682815image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.0058023301232< 0.1%
 
0.0039889157162< 0.1%
 
0.00054065341582< 0.1%
 
0.0011888400242< 0.1%
 
0.00076913686952< 0.1%
 
0.0028505220562< 0.1%
 
0.0080943345482< 0.1%
 
0.0083660944772< 0.1%
 
0.0016918439652< 0.1%
 
0.0021160320812< 0.1%
 
Other values (13498)1352099.9%
 
ValueCountFrequency (%) 
01< 0.1%
 
3.259727526e-061< 0.1%
 
3.940413088e-061< 0.1%
 
5.583890563e-051< 0.1%
 
6.238861337e-051< 0.1%
 
ValueCountFrequency (%) 
11< 0.1%
 
0.97025007031< 0.1%
 
0.96470983431< 0.1%
 
0.95721515351< 0.1%
 
0.78418761391< 0.1%
 

lastprice
Real number (ℝ≥0)

HIGH CORRELATION

Distinct count10184
Unique (%)75.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.05981215805634262
Minimum0.0
Maximum1.0
Zeros1
Zeros (%)< 0.1%
Memory size105.8 KiB
2020-08-03T17:32:06.787217image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.00497621818
Q10.01934933758
median0.03943086941
Q30.07354196011
95-th percentile0.1755151367
Maximum1
Range1
Interquartile range (IQR)0.05419262253

Descriptive statistics

Standard deviation0.07229631377
Coefficient of variation (CV)1.20872271
Kurtosis39.75592151
Mean0.05981215806
Median Absolute Deviation (MAD)0.02443742217
Skewness4.788344496
Sum809.8566201
Variance0.005226756984
2020-08-03T17:32:06.879789image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.018433461946< 0.1%
 
0.022801967876< 0.1%
 
0.012391042526< 0.1%
 
0.049306958996< 0.1%
 
0.0055729070986< 0.1%
 
0.043770796336< 0.1%
 
0.02376548885< 0.1%
 
0.013534202955< 0.1%
 
0.037475248545< 0.1%
 
0.028362626825< 0.1%
 
Other values (10174)1348499.6%
 
ValueCountFrequency (%) 
01< 0.1%
 
4.082715823e-061< 0.1%
 
4.082715823e-051< 0.1%
 
4.490987405e-051< 0.1%
 
7.757160063e-052< 0.1%
 
ValueCountFrequency (%) 
11< 0.1%
 
0.99968154821< 0.1%
 
0.96077326641< 0.1%
 
0.96056096521< 0.1%
 
0.94905995471< 0.1%
 

nbb
Real number (ℝ≥0)

HIGH CORRELATION

Distinct count8776
Unique (%)64.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.05980527851351773
Minimum0.0
Maximum1.0
Zeros2
Zeros (%)< 0.1%
Memory size105.8 KiB
2020-08-03T17:32:06.985211image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.004973903242
Q10.01935815861
median0.03942284916
Q30.0735610027
95-th percentile0.1754600626
Maximum1
Range1
Interquartile range (IQR)0.0542028441

Descriptive statistics

Standard deviation0.07225162544
Coefficient of variation (CV)1.208114522
Kurtosis39.71749354
Mean0.05980527851
Median Absolute Deviation (MAD)0.02444273824
Skewness4.784211578
Sum809.7634711
Variance0.005220297379
2020-08-03T17:32:07.081293image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.0284246379580.1%
 
0.00151924789170.1%
 
0.0100221352870.1%
 
0.0123990231170.1%
 
0.0300582378470.1%
 
0.0322309256870.1%
 
0.028089749986< 0.1%
 
0.0069754714986< 0.1%
 
0.0030384957816< 0.1%
 
0.0068447835076< 0.1%
 
Other values (8766)1347399.5%
 
ValueCountFrequency (%) 
02< 0.1%
 
4.083999706e-052< 0.1%
 
8.167999412e-052< 0.1%
 
0.00028587997942< 0.1%
 
0.00035122397471< 0.1%
 
ValueCountFrequency (%) 
11< 0.1%
 
0.9996651121< 0.1%
 
0.96138169881< 0.1%
 
0.96080177081< 0.1%
 
0.94866412371< 0.1%
 

nbo
Real number (ℝ≥0)

HIGH CORRELATION

Distinct count8815
Unique (%)65.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.05979713517544261
Minimum0.0
Maximum1.0
Zeros2
Zeros (%)< 0.1%
Memory size105.8 KiB
2020-08-03T17:32:07.185846image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.00496923554
Q10.01933999217
median0.03940625408
Q30.0735450124
95-th percentile0.1753961842
Maximum1
Range1
Interquartile range (IQR)0.05420502024

Descriptive statistics

Standard deviation0.07231182245
Coefficient of variation (CV)1.209285733
Kurtosis39.88743264
Mean0.05979713518
Median Absolute Deviation (MAD)0.02442796057
Skewness4.795638201
Sum809.6532103
Variance0.005228999667
2020-08-03T17:32:07.279187image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.0223593158470.1%
 
0.00723821647770.1%
 
0.0015178221770.1%
 
0.00266026896570.1%
 
0.0165654785270.1%
 
0.0046187491846< 0.1%
 
0.017520237636< 0.1%
 
0.011555033296< 0.1%
 
0.024587087096< 0.1%
 
0.010012730126< 0.1%
 
Other values (8805)1347599.5%
 
ValueCountFrequency (%) 
02< 0.1%
 
4.080167124e-052< 0.1%
 
8.160334247e-052< 0.1%
 
0.00028561169872< 0.1%
 
0.00035089437261< 0.1%
 
ValueCountFrequency (%) 
11< 0.1%
 
0.99989391571< 0.1%
 
0.96158930671< 0.1%
 
0.96092831961< 0.1%
 
0.94916111761< 0.1%
 

imbside
Boolean

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size105.8 KiB
0
6890
1
6650
ValueCountFrequency (%) 
0689050.9%
 
1665049.1%
 

imbalancesize
Real number (ℝ≥0)

Distinct count12293
Unique (%)90.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.011663628691065
Minimum0.0
Maximum1.0
Zeros1
Zeros (%)< 0.1%
Memory size105.8 KiB
2020-08-03T17:32:07.728250image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile3.287140012e-05
Q10.0004155223888
median0.002195222276
Q30.008418414509
95-th percentile0.04981041291
Maximum1
Range1
Interquartile range (IQR)0.00800289212

Descriptive statistics

Standard deviation0.03791591344
Coefficient of variation (CV)3.250781935
Kurtosis165.38995
Mean0.01166362869
Median Absolute Deviation (MAD)0.002085928149
Skewness10.70734698
Sum157.9255325
Variance0.001437616492
2020-08-03T17:32:07.832746image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.558832354e-0570.1%
 
4.765825259e-056< 0.1%
 
6.448257531e-056< 0.1%
 
4.714648612e-055< 0.1%
 
2.654788567e-055< 0.1%
 
6.908847355e-065< 0.1%
 
1.944712589e-055< 0.1%
 
1.867947618e-055< 0.1%
 
2.526846949e-055< 0.1%
 
2.597214839e-054< 0.1%
 
Other values (12283)1348799.6%
 
ValueCountFrequency (%) 
01< 0.1%
 
6.397080884e-081< 0.1%
 
1.279416177e-071< 0.1%
 
2.558832354e-071< 0.1%
 
3.83824853e-072< 0.1%
 
ValueCountFrequency (%) 
11< 0.1%
 
0.88427533551< 0.1%
 
0.73682658731< 0.1%
 
0.7051213111< 0.1%
 
0.68767947811< 0.1%
 

notional_imbalance
Real number (ℝ≥0)

Distinct count13534
Unique (%)> 99.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.012332210797616754
Minimum0.0
Maximum1.0
Zeros1
Zeros (%)< 0.1%
Memory size105.8 KiB
2020-08-03T17:32:07.938677image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile2.494251128e-05
Q10.0003601479137
median0.002415329316
Q30.01003843476
95-th percentile0.05186883542
Maximum1
Range1
Interquartile range (IQR)0.00967828685

Descriptive statistics

Standard deviation0.0366713497
Coefficient of variation (CV)2.973623327
Kurtosis171.769173
Mean0.0123322108
Median Absolute Deviation (MAD)0.002337504728
Skewness10.45264749
Sum166.9781342
Variance0.001344787889
2020-08-03T17:32:08.035095image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.00024498791862< 0.1%
 
0.00011788807492< 0.1%
 
3.863093949e-062< 0.1%
 
3.661221337e-062< 0.1%
 
5.174481767e-072< 0.1%
 
7.219676666e-062< 0.1%
 
0.00096810316651< 0.1%
 
0.0093164971491< 0.1%
 
0.024029343861< 0.1%
 
0.0015866628741< 0.1%
 
Other values (13524)1352499.9%
 
ValueCountFrequency (%) 
01< 0.1%
 
1.019680931e-071< 0.1%
 
1.612889805e-071< 0.1%
 
1.636276982e-071< 0.1%
 
1.74826029e-071< 0.1%
 
ValueCountFrequency (%) 
11< 0.1%
 
0.86770014791< 0.1%
 
0.84751598211< 0.1%
 
0.8414876641< 0.1%
 
0.73110080121< 0.1%
 
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size105.8 KiB
0
10086
1
3454
ValueCountFrequency (%) 
01008674.5%
 
1345425.5%
 

matchedsize
Real number (ℝ≥0)

Distinct count13345
Unique (%)98.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.013611987335605022
Minimum0.0
Maximum1.0
Zeros2
Zeros (%)< 0.1%
Memory size105.8 KiB
2020-08-03T17:32:08.146146image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.0001130181893
Q10.0009973790092
median0.00384608804
Q30.01139567042
95-th percentile0.05630751941
Maximum1
Range1
Interquartile range (IQR)0.01039829141

Descriptive statistics

Standard deviation0.03623107537
Coefficient of variation (CV)2.661703577
Kurtosis154.472265
Mean0.01361198734
Median Absolute Deviation (MAD)0.003416598615
Skewness9.639695021
Sum184.3063085
Variance0.001312690823
2020-08-03T17:32:08.248926image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
5.902742752e-053< 0.1%
 
4.509603646e-053< 0.1%
 
2.825123662e-063< 0.1%
 
0.0083088476043< 0.1%
 
0.00018762352523< 0.1%
 
0.00043551046963< 0.1%
 
0.0014215669133< 0.1%
 
9.638968795e-053< 0.1%
 
8.014522689e-053< 0.1%
 
0.00063828372042< 0.1%
 
Other values (13335)1351199.8%
 
ValueCountFrequency (%) 
02< 0.1%
 
1.059421373e-062< 0.1%
 
1.200677556e-061< 0.1%
 
1.765702289e-061< 0.1%
 
2.524954273e-061< 0.1%
 
ValueCountFrequency (%) 
11< 0.1%
 
0.8208654771< 0.1%
 
0.81496515321< 0.1%
 
0.79065623541< 0.1%
 
0.76916484881< 0.1%
 

currentreferenceprice
Real number (ℝ≥0)

HIGH CORRELATION

Distinct count9549
Unique (%)70.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.05979393352178623
Minimum0.0
Maximum1.0
Zeros2
Zeros (%)< 0.1%
Memory size105.8 KiB
2020-08-03T17:32:08.358229image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.004974633999
Q10.01934591226
median0.03941423516
Q30.07350630375
95-th percentile0.1754547718
Maximum1
Range1
Interquartile range (IQR)0.05416039149

Descriptive statistics

Standard deviation0.07227989271
Coefficient of variation (CV)1.208816488
Kurtosis39.78450714
Mean0.05979393352
Median Absolute Deviation (MAD)0.0244313567
Skewness4.789966878
Sum809.6098599
Variance0.00522438289
2020-08-03T17:32:08.457801image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.0460995947270.1%
 
0.0418794104870.1%
 
0.0393734216< 0.1%
 
0.013529894336< 0.1%
 
0.032214617186< 0.1%
 
0.028810716176< 0.1%
 
0.030100443656< 0.1%
 
0.012387097836< 0.1%
 
0.023578340746< 0.1%
 
0.0040365205116< 0.1%
 
Other values (9539)1347899.5%
 
ValueCountFrequency (%) 
02< 0.1%
 
4.081416088e-051< 0.1%
 
4.489557697e-051< 0.1%
 
8.570973785e-052< 0.1%
 
0.00028569912621< 0.1%
 
ValueCountFrequency (%) 
12< 0.1%
 
0.96076942861< 0.1%
 
0.96040210111< 0.1%
 
0.94890067061< 0.1%
 
0.94782317671< 0.1%
 

nearindicativeprice
Real number (ℝ≥0)

ZEROS

Distinct count6924
Unique (%)51.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.009568577663112374
Minimum0.0
Maximum1.0
Zeros3622
Zeros (%)26.8%
Memory size105.8 KiB
2020-08-03T17:32:08.564857image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.003179003179
Q30.007403257403
95-th percentile0.02099332099
Maximum1
Range1
Interquartile range (IQR)0.007403257403

Descriptive statistics

Standard deviation0.04278040973
Coefficient of variation (CV)4.47092674
Kurtosis106.0789199
Mean0.009568577663
Median Absolute Deviation (MAD)0.003179003179
Skewness9.887576282
Sum129.5585416
Variance0.001830163457
2020-08-03T17:32:08.660452image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0362226.8%
 
0.42946742951280.9%
 
1.000001e-06990.7%
 
0.0022000022100.1%
 
0.004500004590.1%
 
0.003800003890.1%
 
0.001600001680.1%
 
0.004200004280.1%
 
0.00900000980.1%
 
0.005600005670.1%
 
Other values (6914)963271.1%
 
ValueCountFrequency (%) 
0362226.8%
 
1.000001e-06990.7%
 
5.000005e-066< 0.1%
 
0.000140000141< 0.1%
 
0.0001480001482< 0.1%
 
ValueCountFrequency (%) 
11< 0.1%
 
0.42946742951280.9%
 
0.12577612581< 0.1%
 
0.12550512551< 0.1%
 
0.11917011921< 0.1%
 

farindicativeprice
Real number (ℝ≥0)

ZEROS

Distinct count3802
Unique (%)28.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.02691208934803031
Minimum0.0
Maximum1.0
Zeros7729
Zeros (%)57.1%
Memory size105.8 KiB
2020-08-03T17:32:08.764673image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30.03538087829
95-th percentile0.1192665831
Maximum1
Range1
Interquartile range (IQR)0.03538087829

Descriptive statistics

Standard deviation0.05869892623
Coefficient of variation (CV)2.181135975
Kurtosis64.75311816
Mean0.02691208935
Median Absolute Deviation (MAD)0
Skewness6.098403884
Sum364.3896898
Variance0.00344556394
2020-08-03T17:32:08.860517image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0772957.1%
 
0.0246880259170.1%
 
0.0030165433596< 0.1%
 
0.04169974285< 0.1%
 
0.0085574572135< 0.1%
 
0.042676150265< 0.1%
 
0.0082161115175< 0.1%
 
0.043525545365< 0.1%
 
0.021893754175< 0.1%
 
0.038191026585< 0.1%
 
Other values (3792)576342.6%
 
ValueCountFrequency (%) 
0772957.1%
 
0.0011986790722< 0.1%
 
0.0014368272312< 0.1%
 
0.0016035309432< 0.1%
 
0.0016352840312< 0.1%
 
ValueCountFrequency (%) 
12< 0.1%
 
0.93638268822< 0.1%
 
0.92011716892< 0.1%
 
0.91371098341< 0.1%
 
0.86802622812< 0.1%
 

matched_to_unmatched
Real number (ℝ≥0)

SKEWED

Distinct count13521
Unique (%)99.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.0024916821086949435
Minimum0.0
Maximum1.0
Zeros1
Zeros (%)< 0.1%
Memory size105.8 KiB
2020-08-03T17:32:08.968930image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile3.100366932e-05
Q10.0002054723263
median0.0007196214763
Q30.001924664085
95-th percentile0.007949038039
Maximum1
Range1
Interquartile range (IQR)0.001719191759

Descriptive statistics

Standard deviation0.01438305909
Coefficient of variation (CV)5.772429412
Kurtosis2623.700714
Mean0.002491682109
Median Absolute Deviation (MAD)0.0006067932662
Skewness44.00783743
Sum33.73737575
Variance0.0002068723888
2020-08-03T17:32:09.068724image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.00044556992452< 0.1%
 
0.00048051569632< 0.1%
 
0.0015028483132< 0.1%
 
0.0047366980592< 0.1%
 
0.01029652912< 0.1%
 
0.00014336377512< 0.1%
 
0.0068594227042< 0.1%
 
0.028077005182< 0.1%
 
0.0087286315232< 0.1%
 
5.327616842e-052< 0.1%
 
Other values (13511)1352099.9%
 
ValueCountFrequency (%) 
01< 0.1%
 
1.027465555e-071< 0.1%
 
1.474172835e-071< 0.1%
 
2.326045886e-071< 0.1%
 
3.859410318e-071< 0.1%
 
ValueCountFrequency (%) 
11< 0.1%
 
0.83032176211< 0.1%
 
0.40224608221< 0.1%
 
0.35490387381< 0.1%
 
0.30862268721< 0.1%
 

pct_move_snapshot_to_close
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing13540
Missing (%)100.0%
Memory size105.9 KiB

minute
Real number (ℝ≥0)

ZEROS

Distinct count6
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.3183825701624815
Minimum0.0
Maximum1.0
Zeros2701
Zeros (%)19.9%
Memory size105.8 KiB
2020-08-03T17:32:09.176761image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10.1
median0.1
Q30.6
95-th percentile0.6
Maximum1
Range1
Interquartile range (IQR)0.5

Descriptive statistics

Standard deviation0.2633389633
Coefficient of variation (CV)0.8271148862
Kurtosis-1.88785764
Mean0.3183825702
Median Absolute Deviation (MAD)0.1
Skewness-0.008490699685
Sum4310.9
Variance0.06934740958
2020-08-03T17:32:09.276030image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.6532139.3%
 
0.1410430.3%
 
0270119.9%
 
0.5141210.4%
 
0.91< 0.1%
 
11< 0.1%
 
ValueCountFrequency (%) 
0270119.9%
 
0.1410430.3%
 
0.5141210.4%
 
0.6532139.3%
 
0.91< 0.1%
 
ValueCountFrequency (%) 
11< 0.1%
 
0.91< 0.1%
 
0.6532139.3%
 
0.5141210.4%
 
0.1410430.3%
 

day
Real number (ℝ≥0)

ZEROS

Distinct count5
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.48601920236336776
Minimum0.0
Maximum1.0
Zeros1975
Zeros (%)14.6%
Memory size105.8 KiB
2020-08-03T17:32:09.379946image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10.1
median0.7
Q30.8
95-th percentile1
Maximum1
Range1
Interquartile range (IQR)0.7

Descriptive statistics

Standard deviation0.37651959
Coefficient of variation (CV)0.7747010573
Kurtosis-1.681960878
Mean0.4860192024
Median Absolute Deviation (MAD)0.3
Skewness-0.1152296116
Sum6580.7
Variance0.1417670016
2020-08-03T17:32:09.477613image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.7388728.7%
 
0.1382228.2%
 
0197514.6%
 
1196414.5%
 
0.8189214.0%
 
ValueCountFrequency (%) 
0197514.6%
 
0.1382228.2%
 
0.7388728.7%
 
0.8189214.0%
 
1196414.5%
 
ValueCountFrequency (%) 
1196414.5%
 
0.8189214.0%
 
0.7388728.7%
 
0.1382228.2%
 
0197514.6%
 

quarter
Categorical

HIGH CORRELATION

Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size105.8 KiB
0
5914
1
3840
0.5
3786
ValueCountFrequency (%) 
0591443.7%
 
1384028.4%
 
0.5378628.0%
 
2020-08-03T17:32:09.649241image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Length

Max length3
Median length3
Mean length3
Min length3

year
Boolean

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size105.8 KiB
0
7626
1
5914
ValueCountFrequency (%) 
0762656.3%
 
1591443.7%
 

week
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct count7
Unique (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.44402027199103555
Minimum0.0
Maximum1.0
Zeros1964
Zeros (%)14.5%
Memory size105.8 KiB
2020-08-03T17:32:09.750215image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10.1034482759
median0.4482758621
Q30.8965517241
95-th percentile1
Maximum1
Range1
Interquartile range (IQR)0.7931034483

Descriptive statistics

Standard deviation0.3657195861
Coefficient of variation (CV)0.8236551553
Kurtosis-1.410765382
Mean0.444020272
Median Absolute Deviation (MAD)0.3448275862
Skewness0.3085576813
Sum6012.034483
Variance0.1337508156
2020-08-03T17:32:09.849169image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.1379310345197514.6%
 
0.1034482759197514.6%
 
0196414.5%
 
1192814.2%
 
0.8965517241191214.1%
 
0.5517241379189414.0%
 
0.4482758621189214.0%
 
ValueCountFrequency (%) 
0196414.5%
 
0.1034482759197514.6%
 
0.1379310345197514.6%
 
0.4482758621189214.0%
 
0.5517241379189414.0%
 
ValueCountFrequency (%) 
1192814.2%
 
0.8965517241191214.1%
 
0.5517241379189414.0%
 
0.4482758621189214.0%
 
0.1379310345197514.6%
 

month
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct count6
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.4449250896813674
Minimum0.0
Maximum1.0
Zeros1964
Zeros (%)14.5%
Memory size105.8 KiB
2020-08-03T17:32:09.955346image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10.1428571429
median0.4285714286
Q30.8571428571
95-th percentile1
Maximum1
Range1
Interquartile range (IQR)0.7142857143

Descriptive statistics

Standard deviation0.3542395423
Coefficient of variation (CV)0.7961779422
Kurtosis-1.364953584
Mean0.4449250897
Median Absolute Deviation (MAD)0.2857142857
Skewness0.3084892935
Sum6024.285714
Variance0.1254856534
2020-08-03T17:32:10.060354image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.1428571429395029.2%
 
0196414.5%
 
1192814.2%
 
0.8571428571191214.1%
 
0.5714285714189414.0%
 
0.4285714286189214.0%
 
ValueCountFrequency (%) 
0196414.5%
 
0.1428571429395029.2%
 
0.4285714286189214.0%
 
0.5714285714189414.0%
 
0.8571428571191214.1%
 
ValueCountFrequency (%) 
1192814.2%
 
0.8571428571191214.1%
 
0.5714285714189414.0%
 
0.4285714286189214.0%
 
0.1428571429395029.2%
 

Interactions

2020-08-03T17:31:27.577360image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:27.733603image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:27.928473image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:28.089958image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:28.227817image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:28.386486image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:28.546408image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:28.702114image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:28.829384image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:28.956775image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:29.103909image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:29.261068image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:29.411688image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:29.550728image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:29.689910image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:30.278115image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:30.421455image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:30.559640image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:30.726445image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:30.875642image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:30.992441image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:31.117626image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:31.262699image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:31.398470image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:31.519424image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:31.660080image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:31.826510image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:31.957722image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:32.131424image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:32.260773image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:32.383420image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:32.502541image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:32.618003image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:32.747671image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:32.875209image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:33.000601image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:33.112885image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:33.230858image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:33.347449image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:33.458151image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:33.569378image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:33.684637image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:33.803311image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:33.921505image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:34.037760image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:34.163981image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:34.289515image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:34.423157image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:34.558373image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:34.698276image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:34.836268image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:34.987360image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:35.133119image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:35.266924image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:35.414587image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:35.550376image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:35.707019image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:35.880955image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:36.013412image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:36.130143image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:36.243771image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:36.354937image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:36.466927image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:36.584889image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:36.699153image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:36.816853image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:36.930005image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:37.221611image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:37.369919image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:37.524682image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:37.650572image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:37.777354image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:37.906516image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:38.027525image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:38.155071image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:38.272611image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:38.401112image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:38.536887image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:38.699140image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:38.836688image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:38.955100image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:39.070017image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:39.192673image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:39.308103image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:39.418882image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:39.531772image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:39.645816image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:39.758077image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:39.875397image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:39.987157image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:40.105985image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:40.217884image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:40.338453image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:40.452066image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:40.566144image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:40.681000image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:40.792737image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:40.904421image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:41.022401image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:41.138896image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:41.251588image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:41.366293image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:41.475078image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:41.593228image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:41.703126image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:41.819592image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:41.930091image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:42.040745image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:42.155464image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:42.283039image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:42.394309image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:42.506540image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:42.620699image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:42.735637image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:42.849035image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:42.963761image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:43.075499image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:43.198075image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:43.316916image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:43.429346image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:43.547583image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:43.690292image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:43.826724image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:43.959560image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:44.092818image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:44.257290image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:44.390626image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:44.514985image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:44.632839image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:44.753933image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:44.884979image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:45.005549image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:45.358969image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:45.501116image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:45.632182image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:45.760343image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:45.911521image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:46.052055image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:46.178472image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:46.319578image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:46.450881image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:46.586270image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:46.719527image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:46.861264image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:46.974625image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:47.086503image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:47.202265image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:47.318126image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:47.438046image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:47.556617image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:47.679641image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:47.800492image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:47.920246image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:48.033225image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:48.158882image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:48.274779image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:48.391371image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:48.501480image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:48.616321image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:48.728823image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:48.845784image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:48.966397image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:49.092245image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:49.219954image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:49.337915image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:49.451550image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:49.564829image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:49.677481image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:49.792129image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:49.923475image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:50.116390image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:50.263332image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:50.390720image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:50.517885image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:50.639802image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:50.777764image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:50.902934image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:51.014993image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:51.133146image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:51.262480image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:51.386821image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:51.499198image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:51.624012image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:51.757131image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:51.888550image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:52.002368image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:52.173999image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:52.317635image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:52.459799image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:52.583300image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:52.732673image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:52.864405image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:52.997748image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:53.149277image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:53.289086image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:53.405406image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:53.519505image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:53.653369image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:53.769850image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:53.896889image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:54.018280image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:54.144598image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:54.266661image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:54.382339image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:54.493741image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:54.615229image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:54.730774image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:54.873223image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:54.991114image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:55.106412image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:55.224622image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:55.359469image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:55.774358image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:55.904289image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:56.020612image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:56.135273image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:56.254121image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:56.385162image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:56.498571image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:56.615512image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:56.746473image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:56.888004image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:57.023344image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:57.148306image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:57.286179image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:57.424271image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:57.545342image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:57.673769image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:57.862833image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:58.008559image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:58.155208image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:58.283041image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:58.404589image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:58.525029image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:58.641992image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:58.753163image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:58.867784image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:58.979589image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:59.097688image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:59.227010image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:59.337642image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:59.454456image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:59.566680image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:59.675256image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:59.789496image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:31:59.908811image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:00.022014image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:00.144210image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:00.256682image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:00.379097image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:00.499988image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:00.613398image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:00.726072image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:00.865131image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:00.979948image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:01.089467image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:01.208982image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:01.317699image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:01.439307image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:01.555366image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:01.665787image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:01.775287image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:01.889499image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:02.017248image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:02.137294image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:02.258262image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:02.402115image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:02.519271image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:02.630973image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:02.739506image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:02.849960image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:02.957217image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:03.070342image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:03.201540image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:03.319213image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:03.431255image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:03.542052image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:03.652734image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:03.763444image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:03.875214image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:03.988610image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:04.110832image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:04.231192image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:04.347005image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:04.462313image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:04.577944image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:04.687190image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:04.799190image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:04.913014image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Correlations

2020-08-03T17:32:10.209705image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
2020-08-03T17:32:10.520083image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
2020-08-03T17:32:10.814248image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
2020-08-03T17:32:11.136685image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Missing values

2020-08-03T17:32:05.182008image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:05.661036image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T17:32:05.897333image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Sample

First rows

df_indexsymbolcurrentvolumelastpricenbbnboimbsideimbalancesizenotional_imbalanceimbalancetypematchedsizecurrentreferencepricenearindicativepricefarindicativepricematched_to_unmatchedpct_move_snapshot_to_closeminutedayquarteryearweekmonth
000.00.1342390.1745970.1746970.1745330.00.0007230.0033470.00.0053530.1745500.0216000.171800.000151NaN0.10.70.01.00.1379310.142857
110.00.1366200.1746790.1747300.1745741.00.0013800.0063910.00.0070920.1746150.0215000.000000.000218NaN0.60.70.01.00.1379310.142857
220.00.1072340.1787450.1787980.1786301.00.0012520.0059310.00.0358280.1786880.0220010.174650.000039NaN0.10.00.01.00.1034480.142857
330.00.1103140.1787290.1787810.1786300.00.0088720.0420330.00.0375770.1786880.0221670.000000.000264NaN0.60.00.01.00.1034480.142857
440.00.1949330.1666360.1666840.1665280.00.1496680.6614361.00.1090030.1665750.0000000.000000.001536NaN0.01.00.01.00.0000000.000000
550.00.2082300.1674260.1674600.1673280.00.0978460.4344550.00.1546450.1673670.0215600.000000.000708NaN0.61.00.01.00.0000000.000000
660.00.0933420.1725150.1725650.1724121.00.1896950.8677001.00.1211920.1724600.0000000.000000.001752NaN0.00.11.00.01.0000001.000000
770.00.0965060.1723680.1724260.1722651.00.0904510.4133930.00.1714240.1723210.0212250.168180.000590NaN0.50.11.00.01.0000001.000000
880.00.1461960.1569190.1569480.1568170.00.2035610.8475161.00.2404060.1568530.0000000.000000.000947NaN0.00.71.00.00.8965520.857143
990.00.1579120.1570420.1570870.1569560.00.1079900.4499600.00.3023190.1570080.0194550.155090.000400NaN0.60.71.00.00.8965520.857143

Last rows

df_indexsymbolcurrentvolumelastpricenbbnboimbsideimbalancesizenotional_imbalanceimbalancetypematchedsizecurrentreferencepricenearindicativepricefarindicativepricematched_to_unmatchedpct_move_snapshot_to_closeminutedayquarteryearweekmonth
13530136441.00.1351750.0120770.0120800.0120691.00.1046790.0365021.00.0510500.0120690.0000000.0000000.002295NaN0.01.00.01.00.0000000.000000
13531136451.00.1402460.0120850.0120890.0120771.00.0913460.0318730.00.0587550.0120850.0015950.0126140.001740NaN0.61.00.01.00.0000000.000000
13532136461.00.0188480.0320170.0320270.0319971.00.0125410.0109591.00.0096960.0320110.0000000.0000000.001447NaN0.00.11.00.01.0000001.000000
13533136471.00.0197700.0320040.0320190.0319891.00.0005450.0004760.00.0137370.0319940.0040460.0000000.000044NaN0.60.11.00.01.0000001.000000
13534136481.00.0274880.0300900.0300990.0300711.00.0334320.0275181.00.0140300.0300800.0000000.0000000.002667NaN0.00.71.00.00.8965520.857143
13535136491.00.0285180.0300320.0300420.0300141.00.0160850.0132160.00.0196630.0300270.0037470.0000000.000915NaN0.60.71.00.00.8965520.857143
13536136501.00.0224420.0250800.0250840.0250601.00.0236290.0163321.00.0050680.0250640.0000000.0000000.005217NaN0.00.10.50.00.5517240.571429
13537136511.00.0235760.0250800.0250920.0250691.00.0137450.0095010.00.0082320.0250800.0031550.0000000.001868NaN0.60.10.50.00.5517240.571429
13538136521.00.0406160.0216670.0216620.0216410.00.0314070.0188841.00.0027300.0216480.0000000.0000000.012873NaN0.00.80.50.00.4482760.428571
13539136531.00.0423830.0216510.0216620.0216410.00.0188410.0113210.00.0065480.0216440.0029340.0232910.003220NaN0.60.80.50.00.4482760.428571